﻿CREATE PROCEDURE [dbo].[UpdateAllLineitems_SP] 
	-- Add the parameters for the stored procedure here
 @Price float,
 @Multiple int,
 @TotalPrice float,
 @TotalOfferedPrice float,
 @PreDiscountPrice float,
 @MarketRetailPrice float,
 @MarketPriceEuro float,
 @SeasonalPriceEuro float,
 @SeasonalPriceCurr float,
 @BillingPrice float,
 @COM float,
 @QuoteLineItemID int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	Update QuoteLineItem_Tbl set 
Price=@Price,  TotalPrice=@TotalPrice, TotalOfferedPrice=@TotalOfferedPrice, 
PreDiscountPrice=@PreDiscountPrice,  MarketPriceEuro=@MarketPriceEuro, 
MarketRetailPrice=@MarketRetailPrice, SeasonalPriceEuro=@SeasonalPriceEuro, 
SeasonalPriceCurr=@SeasonalPriceCurr,   BillingPrice=@BillingPrice, COM=@COM 
where QuoteLineItemID=@QuoteLineItemID
END